www.gusucode.com > VC++ ASP文件上传组件源代码+调用示例-源码程序 > VC++ ASP文件上传组件源代码+调用示例-源码程序/code/asp_demo/ASPUploader Samples/Sample3.asp
<%@ Language=JScript%>
<%
Response.Buffer = true;
%>
<!-- #include file="adojavas.inc" -->
<%
var form = Server.CreateObject("MyRequest.Form");
form.Init();
var cn = Server.CreateObject("ADODB.Connection");
var rs = Server.CreateObject("ADODB.Recordset");
var id = form.Item("id").Value;
cn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Database.mdb"));
rs.Open("SELECT * FROM Users WHERE id='" + id + "'", cn, adOpenForwardOnly, adLockOptimistic, adCmdText);
if(rs.EOF) {
rs.AddNew();
rs.Fields("id") = id;
}
rs.Fields("name") = form.Item("name").Value;
rs.Fields("password") = form.Item("password").Value;
rs.Fields("email") = form.Item("email").Value;
var file = form.Item("file").Item(1);
rs.Fields("FileType") = file.ContentType;
rs.Fields("file").AppendChunk(file.Value);
rs.Update();
rs.Close();
rs.Open("SELECT * FROM Users WHERE id='" + id + "'", cn, adOpenForwardOnly, adLockReadOnly, adCmdText);
%>
<html>
<head>
<link href="style.css" rel=stylesheet type=text/css>
<title>ASP Uploader Sample 3</title>
</head>
<body>
<h1>Sample 3: Mix upload to a database</h1>
<br>
<table width=100% cellpadding=2><tr><td bgcolor="#000000">
<table width=100% bgcolor="#ffffff" cellpadding=4>
<tr>
<td align=right>ID:</td>
<td width=80% style="font-size:65%; color:#ff0000"><%= rs("id") %></td>
</tr>
<tr>
<td align=right>Name:</td>
<td width=80% style="font-size:65%; color:#ff0000"><%= rs("name") %></td>
</tr>
<tr>
<td align=right>Password:</td>
<td width=80% style="font-size:65%; color:#ff0000"><%= rs("password") %></td>
</tr>
<tr>
<td align=right>email:</td>
<td width=80% style="font-size:65%; color:#ff0000"><%= rs("email") %></td>
</tr>
<tr>
<td align=right>File:</td>
<td width=80% style="font-size:65%; color:#ff0000"><a href=Show.asp?id=<%= id%>>Show Uploaded File [it might be downloaded]</a></td>
</tr>
</table>
</td></tr></table>
<br>
<div>
Designed by Al-Mutairi, Fayez <br>
e-mail: <a href="mailto:fayezmm@yahoo.com">fayezmm@yahoo.com</a><br>
Copyright? 2001
</div>
</body>
</html>